Skip to main content

Full text of "CS_135_Syllabus_Arthus_"

See other formats


Ancilla College 

Course Syllabus - CS 135 - Sections 1 and 2 



Section 01 - 10:00am-ll:15am Monday and Wednesday 
Section 02 - l:30am-2:45pm Monday and Wednesday 

Office Hours - By Appointment - email or phone 

Contact Information - 

Instructor - Gerard Arthus 

Email - garthus801@gmail.com 

Phone: 

Cell - 631-335-5250 

Home - 574-855-1617 

Required Materials (available On-line or at the Ancilla 

Bookstore) - 

Text - Pinard/Romer, CMPTR, 9781111527990 Course Technology, 2012 
SAM 2010 Assessment, Training and Projects (Access code card). 

ISBN#9781111669362 (you can by SAM Access without buying the book). 

Resources Needed - 

Computer with Internet access, using Windows 7, Windows XP or Vista 
Microsoft Office 2010 Professional Software, available for purchase at the 

Ancilla Bookstore for $20.00 

A flash drive (USB Stick), to use for backing up all course files in case of 

system failure; 4-8GB is the recommended size. 

Course Description - 

This course provides a brief introduction to Computers and Information Systems; 
the Windows Operating System and file management, and the Internet. The main 
emphasis will be on Microsoft Office 2010 Professional Software (Word, Excel, 
PowerPoint and Access). Learning of the applications will be through lab 
exercises, On-line activities and problem solving. 

Course Goals - 

This course is a general education requirement for Ancilla students and it is 
project oriented. Students will use these programs to present their research by 



producing various documents and presentations. It is assumed that students have 
a basic understanding of how computers work and have some Internet 
experience. Students who do not have this knowledge or feel uncomfortable when 
working with the computer should notify the instructor. If possible, after-hours 
instruction will be provided to make sure that everyone has a basic understanding 
of computer operations. Basic skills required are: Basic skills required are: using 
a 2-button mouse, using a keyboard, the difference between files and folders, 
starting a program, closing a window, going to a specific web address, 
downloading a file, uploading a file, using an email software, etc. 

Academic Core Values addressed in this course - 

#1. Identify and solve problems using critical thinking. 
#2. Speak and present information in varied contexts. 
#3. Identify and use appropriate computer and communication technologies. 
#4. Articulate ethical values and employ moral reasoning in decision- 
making. 

Student Learning Objectives - 

Through lab projects and teacher led demonstrations and discussions, students will be able to 
demonstrate the basic core objectives including: 



o Understand what Systems are and how they operate 

o Create and edit Word documents 

o Format a multiple page documents 

o Create worksheets and add embedded chart(s) 

o Use formulas, functions and formatting to enhance spreadsheets 

o Create charts & work with large worksheets 

o Create a database using design and data-sheet views 

o Query a database using the select query window 

o Maintain a database using the design and update features 

o Use a design template and text slide layout to create presentations 

o Use the outline tab to a create slide show and clip art 

o Integrate Office applications and the World Wide Web 

o Create a unique and personal online portfolio using skills learned throughout the 

semester 

Measuring student achievement - 

At the completion of this course, students will be able to demonstrate their knowledge & skills 

through: 

o Demonstration of their online portfolio with personal reflections on learning 
o Active participation in the course discussion forums and class activities 
o Completion of homework and original project files in each software application 
o Knowledge of technology and communication concepts and hands-on skills 
exams and quizzes 



All written assignments will be graded for content as well as grammatical 
presentation 



Grading - 

Students have a choice to participate in two types of grading formats. The 
'Academic format'; which entails traditional grades based upon letter grades 'A' 
through 'D' or what I will call, 'the Real-World' format; which grades student work 
based upon it being completely 'acceptable' in its final product or as 
'unacceptable'. In the 'Real-World', one is not given a letter grade for work which 
has been submitted, the work is either acceptable, or it is not. Work is allowed to 
be resubmitted until it becomes acceptable, all within an agreeable time-frame. 
This means that work either gets a grade of 'A' or it is considered incomplete. If 
they choose this method, I am willing to work with students individually (extra 
office hours). The benefit of this type of process is that the students end up with 
a much better product for their efforts. The materials are better understood and 
the portfolio contains better work. While the Real-World format entails more work 
for the instructor, I am willing to do the work, if the student is willing to also do 
the extra work that it takes to better understand the course materials. No one will 
be penalized for choosing either grading format. I must be notified by the second 
week of classes, as to which format a student chooses. 

Class Attendance Policy: 

Attendance will be taken every day, for those students in a sports program or 
receiving financial aid attendance is critical. Also, because of the way class 
lectures are constructed, attendance will be beneficial for helping students do the 
work. Students can schedule additional study time by agreement and I will be 
available when necessary. 

Disability Accommodation Statement: 

If you have any disability that may require accommodation, or if you have 
questions related to any accommodations, please speak with the instructor and 
an Advising Center Lab staff member as soon as possible. The Advising Center 
Lab is located in Room 204 or can be reached at (574) 936-8898, ext. 
302. Please be advised that in order to receive services, you must complete 
the disclosure and accommodations request process. 



Late Work & Make-up Work Policies; 

All assignments are due before the end of the semester. The policy for doing 



the assignments is that they can be redone as many times as the student 
would like. The reasons for this policy are explained in the introductory 
materials posted on the web-assist site. 

Academic Integrity: 

Honesty is required in all courses. You may not submit work that is not your 
own. This includes plagiarism (using someone else's work and not citing it as 
theirs) and cheating (taking or copying someone else's work and passing it on 
as your own). Permitting other students to use your work as their own also 
violates the principle of academic integrity. Ancilla College stresses the 
importance of academic integrity. A student who plagiarizes or cheats will fail 
that assignment or assessment. Any repeated violation of this policy will result 
in dismissal from Ancilla College. All honor violations will be reported to the 
Dean at the time they are detected. Students should understand basic 
copyright rules; attribution must be given if the work is copyrighted in a way 
which restricts its use. If the work is in the Public Domain (as much of my 
materials are); it can actually be used without attribution. You must 
understand the restrictions placed on any materials you may find in books or 
on the Internet. 

Assessment & Grading: 

Course grades are earned by students through academic work that is assessed 
by instructors and recorded in the Office of the Registrar at the end of each 
semester. Grades are standardized measurements of levels of comprehension 
within a course. 



Points earned 


Percentage of total 


Grade 


185 - 200 points 


93 to 100 percent 


A 


179 - 184 points 


90 to 92 percent 


A- 


173 - 178 points 


87 to 89 percent 


B+ 


165 - 172 points 


83 to 86 percent 


B 


159 - 164 points 


80 to 82 percent 


B- 


153 - 158 points 


77 to 79 percent 


C+ 


140 to 152 points 


70 to 76 percent 


C 


129 to 138 points 


64 to 69 percent 


D 


Below 128 points 


Below 64 percent 


F 





Topics covered this week 


Required Things To Do 


Graded Assignments 




Week 1 


• Course Introduction 

• Syllabus review 

• Basic Computer Concepts 

• The principles of Systems 

• Moodle access & usage 

• Internet Archive and the posting 
of documents and ephemera 


• Complete Basic Computer Skills Survey 

• Take Pre-Test (ungraded quiz) 

• Read Chapter 1, Intro to Computer, pg.. 2-29 

• Read Chapter 3, Computer Software, pg.. 76-107 

• Activate your login account: this MUST be done 
while on-campus on any computer! 

• Login to your Ancilla email account at 
www.ancilla.edu/exchange 

• Create an account on Internet Archive 

• Create a CS135 folder on your flash drive and 
your H: drive to save all your course files in 

• Login to Moodle and post to the Discussion fo- 
rum #1 


• Send a test email with a file attachment 
to the instructor at: 

garthus801@gmail.com. Make your sub- 
ject line "CS135-8 Test Email" 

• Quiz: Intro to Computer Concepts 

• Quiz: Computer Software Concepts 

• Post a response to the Discussion Forum 
#1: Introduce yourself and your Comput- 
er experience by Saturday. Respond to 
two classmate posts by the end of the 
week. 


Week 2 


• Internet & Email 

• Windows Navigation/Basic Skills 

• Windows file management 


• Read Chapter 5, Intro to Internet & Email, pg.. 
140-187 

• Read Chapter 7, Exploring Microsoft Windows, 
pg.. 226-248 

• Read Chapter 8, Managing Your Files, pg.. 250- 
267 

• Create your SAM account access 


• Quiz: Intro to Internet & Email Concepts 

• Quiz: Windows navigation & File man- 
agement 

• Complete SAM Exam: Windows 


Week 3 


• Word -Creating a Document 

• Word - Formatting Documents 


• Read Chapter 10, Creating A Document, pg.. 298- 
343 

• Read Chapter 11, Formatting a Long Document, 
pg. 344-382 


• Quiz: Word document creation & edits 

• Quiz: Word formatting 

• Post a response to the Discussion Forum 
#2: Discuss unique ways that you have 
used Word already and ways that you ex- 
pect to use it in your future education or 
career. Respond to two classmate posts. 


Week 4 


• Word - Enhancing a Document 

• Word Capstone Project intra 


• Read Chapter 12, Enhancing a Document, pg. 
382-423 

• Begin work on your Word Capstone Project 
which includes: a resume, business card, and 
cover letter (see instructions in Moodle) 


• Quiz: Word Enhancements 

• Complete SAM Projects: Word 


Week 5 


• Documents "in the cloud" 


• Create a Google Docs login account at 
http://docs.google.com 

• Complete the "Start of Course Feedback Survey" 


• Baseline Writing sample, Mission State- 
ment, Terms of Use Essay 

• Post your thoughts to Discussion Forum 
#3: on creating an online file repository. 
Respond to two classmate posts. 


Week 6 


• Electronic Portfolio Project In- 
troduction 


• Create a Google Sites website for your Portfolio 
at http://sites.google.com. Use your name in 
your site title. For example: 
Portfolio-GerardArthus (do not use spaces) 

• Review the Portfolio website requirements, and 
samples 


• Post your new Portfolio website address 
to Discussion Forum #4: on creating an 
online Portfolio and sharing it with oth- 
ers. Be sure to include the web address 
for your new Portfolio. Respond to two 
classmate posts. 


Week 7 


• Excel -Creating a Workbook 


• Read Chapter 13, Creating a Workbook, pg. 424- 
457 


• Quiz: Creating an Excel Workbook 


Week 8 


• Excel - Formatting a Workbook 


• Read Chapter 14, Formatting a Workbook, pg. 
458-497 


• Quiz: Formatting an Excel Workbook 


Week 9 


• Excel -Working with Formulas 
and Functions 


• Read Chapter 15, Working with Formulas and 
Functions, pg. 498-529 


• Quiz: Formulas and Functions 

• Post a response to the Discussion Forum 
#5: Using Excel. Respond to two class- 
mate posts. 



Week 
10 


• Excel - Inserting & formatting 
Charts 

• Excel Capstone project intro 


• Read Chapter 16, Inserting and Formatting 
Charts, pg. 530-565 

• Begin work on your Excel project family budget 
spreadsheet, (see instructions in Moodle) 


• Quiz: Inserting and Formatting Charts 

• Complete SAM Projects: Excel 

• Word Capstone project is DUE 


Week 
11 


• PowerPoint - Creating a Presen- 
tation 

• PowerPoint - Enhancing a 
Presentation 


• Read Chapter 20, Creating a Presentation 

• Read Chapter 21, Enhancing a Presentation 

• Work on completing your Portfolio website 


• Quiz: Creating PowerPoint presentations 

• Quiz: Enhancing PowerPoint presenta- 
tions 

• Complete SAM Projects: PowerPoint 

• Post a response to the Discussion Forum 
#6: Using PowerPoint. Respond to two 
classmate posts. 


Week 
12 


• PowerPoint Capstone Project 
Intro 

• Access -Creating a database 


• Begin work on your PowerPoint project "About 
Me" presentation (see instructions in Moodle) 

• Read Chapter 17, Creating a Database, pg. 566- 
601 


• Excel Capstone Project is DUE 

• Quiz: creating a database 


Week 
13 


• Access - Maintaining a data- 
base 


• Read Chapter 18, Maintaining and Querying a 
Database, pg. 602-633 


• Quiz: maintaining & querying a database 

• Complete SAM Projects: Access 

• PowerPoint Capstone Project is DUE 


Week 
14 


• Integrating Office Applications 


• Read Chapter 22, Integration, pg. 738-770 


• Quiz: Integration 

• Post your thoughts to Discussion Forum 

#7: on the Portfolio project. Do you think 
it will be valuable to you to chart your 
growth while in college? Respond to two 
classmate posts. 


Week 
15 


• Final Exam review 


• Study for Final Exam 

• Complete the Post Test 

• Complete the Post Skills Survey 

• Complete the Course Evaluations 


• Upload final Portfolio Project website link 
to the Discussion Forum #8: with your fi- 
nal course post about what you learned in 
this course, especially on the portfolio 
website project that you think you might 
use again and/or show your friends, fami- 
ly, teachers, or co-workers. 


Week 
16 


• Final Exam 


• Final Exam: Concepts questions on Moodle 

• Final Exam: Hands-On projects in SAM Projects 




Final Grades will be posted in Moodle by Monday, Dec. 12 

Or, go to https://empower.ancilla.edu and login to see your final grades after Dec. 15 

Have a Merry Christmas!